Question 1
Column
Las 10 provincias con más denuncias en 2024
| Year | Department | Province | Cases |
|---|---|---|---|
| 2024 | LIMA METROPOLITANA | LIMA | 7888 |
| 2024 | LA LIBERTAD | TRUJILLO | 3378 |
| 2024 | PIURA | PIURA | 925 |
| 2024 | PIURA | SULLANA | 830 |
| 2024 | LAMBAYEQUE | CHICLAYO | 664 |
| 2024 | PROV. CONST. DEL CALLAO | CALLAO | 619 |
| 2024 | ANCASH | SANTA | 501 |
| 2024 | LA LIBERTAD | PACASMAYO | 485 |
| 2024 | LA LIBERTAD | ASCOPE | 465 |
| 2024 | AREQUIPA | AREQUIPA | 334 |
Column
Cambios en las top 10 provincias
Question 2
Column
Casos y variación porcentual
| Department | Province | Cases_2018 | Cases_2024 | variacion_pct |
|---|---|---|---|---|
| REGION LIMA | HUARAL | 3 | 314 | 10366.67 |
| CAJAMARCA | SAN MARCOS | 1 | 47 | 4600.00 |
| REGION LIMA | HUAROCHIRI | 1 | 47 | 4600.00 |
| CUSCO | LA CONVENCION | 1 | 43 | 4200.00 |
| MOQUEGUA | ILO | 1 | 26 | 2500.00 |
| TACNA | TACNA | 5 | 121 | 2320.00 |
| LA LIBERTAD | PATAZ | 1 | 24 | 2300.00 |
| APURIMAC | ANDAHUAYLAS | 1 | 23 | 2200.00 |
| CAJAMARCA | CAJABAMBA | 8 | 166 | 1975.00 |
| CAJAMARCA | HUALGAYOC | 1 | 20 | 1900.00 |
Casos y Z Score
| Department | Province | Cases_2018 | Cases_2024 | Z_score |
|---|---|---|---|---|
| LIMA METROPOLITANA | LIMA | 620 | 7888 | 127.82923 |
| LA LIBERTAD | TRUJILLO | 608 | 3378 | 66.92582 |
| PIURA | SULLANA | 67 | 830 | 41.24874 |
| PROV. CONST. DEL CALLAO | CALLAO | 75 | 619 | 32.43891 |
| LA LIBERTAD | PACASMAYO | 35 | 485 | 32.21327 |
| REGION LIMA | HUARAL | 3 | 314 | 31.97599 |
| PIURA | PIURA | 221 | 925 | 31.09549 |
| REGION LIMA | BARRANCA | 29 | 332 | 25.67140 |
| LAMBAYEQUE | CHICLAYO | 189 | 664 | 24.04094 |
| AREQUIPA | AREQUIPA | 41 | 334 | 23.74509 |
Column
Grafico de barras con variación porcentual
Gráfico de barras con el Z-score
Question 3
Column
Casos y variación porcentual
| Department | Province | Cases_2021 | Cases_2024 | variacion_pct |
|---|---|---|---|---|
| APURIMAC | ANDAHUAYLAS | 1 | 23 | 2200.000 |
| CAJAMARCA | CAJABAMBA | 8 | 166 | 1975.000 |
| CAJAMARCA | HUALGAYOC | 1 | 20 | 1900.000 |
| LA LIBERTAD | GRAN CHIMU | 1 | 17 | 1600.000 |
| LORETO | ALTO AMAZONAS | 1 | 17 | 1600.000 |
| REGION LIMA | HUARAL | 21 | 314 | 1395.238 |
| ANCASH | HUARI | 1 | 14 | 1300.000 |
| ICA | PALPA | 1 | 13 | 1200.000 |
| SAN MARTIN | MARISCAL CACERES | 1 | 11 | 1000.000 |
| TUMBES | CONTRALMIRANTE VILLAR | 1 | 11 | 1000.000 |
Casos y Z Score
| Department | Province | Cases_2021 | Cases_2024 | Z_score |
|---|---|---|---|---|
| LIMA METROPOLITANA | LIMA | 1379 | 7888 | 103.35905 |
| LA LIBERTAD | TRUJILLO | 651 | 3378 | 65.21173 |
| PIURA | SULLANA | 114 | 830 | 36.26528 |
| REGION LIMA | HUARAL | 21 | 314 | 26.27494 |
| PIURA | PIURA | 322 | 925 | 24.93891 |
| LA LIBERTAD | PACASMAYO | 93 | 485 | 24.75813 |
| LAMBAYEQUE | CHICLAYO | 188 | 664 | 24.11378 |
| PROV. CONST. DEL CALLAO | CALLAO | 176 | 619 | 23.22642 |
| CAJAMARCA | CAJABAMBA | 8 | 166 | 20.11134 |
| ANCASH | SANTA | 154 | 501 | 19.94671 |
Column
Grafico de barras con variación porcentual
Gráfico de barras con el Z-score
Question 4
Column
Casos y variación porcentual
| Department | Province | Cases_2021 | Cases_2022 | variacion_pct |
|---|---|---|---|---|
| APURIMAC | ANDAHUAYLAS | 1 | 14 | 1300.0000 |
| LA LIBERTAD | GRAN CHIMU | 1 | 13 | 1200.0000 |
| AREQUIPA | CARAVELI | 2 | 21 | 950.0000 |
| TUMBES | CONTRALMIRANTE VILLAR | 1 | 10 | 900.0000 |
| CAJAMARCA | HUALGAYOC | 1 | 8 | 700.0000 |
| AREQUIPA | CAMANA | 6 | 45 | 650.0000 |
| JUNIN | CHANCHAMAYO | 6 | 37 | 516.6667 |
| REGION LIMA | OYON | 1 | 6 | 500.0000 |
| SAN MARTIN | TOCACHE | 3 | 18 | 500.0000 |
| REGION LIMA | CAÑETE | 41 | 242 | 490.2439 |
Casos y Z Score
| Department | Province | Cases_2021 | Cases_2022 | Z_score |
|---|---|---|---|---|
| LIMA METROPOLITANA | LIMA | 1379 | 7658 | 100.75022 |
| PROV. CONST. DEL CALLAO | CALLAO | 176 | 746 | 28.09300 |
| LA LIBERTAD | TRUJILLO | 651 | 1439 | 24.83890 |
| PIURA | SULLANA | 114 | 434 | 20.31118 |
| REGION LIMA | CAÑETE | 41 | 242 | 18.30645 |
| ICA | ICA | 52 | 213 | 14.76683 |
| REGION LIMA | HUAURA | 67 | 242 | 14.74199 |
| AREQUIPA | AREQUIPA | 84 | 266 | 14.28871 |
| PIURA | TALARA | 32 | 147 | 12.93500 |
| REGION LIMA | HUARAL | 21 | 121 | 12.83485 |
Column
Grafico de barras con variación porcentual
Gráfico de barras con el Z-score
Column
Autocorrelación espacial - LISA (aporte desde mi tesis)
Question 6
Column
Número de denuncias en los distritos de Trujillo
